home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Amiga Plus 2002 #11
/
Amiga Plus CD - 2002 - No. 11.iso
/
amigaoscd
/
amigapluscd
/
AP-Website
/
news
/
admin
/
change_news.php
< prev
next >
Wrap
Text File
|
2002-01-27
|
4KB
|
126 lines
<html>
<head>
<title>AmigaPlus News Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#66CCFF" text="#000000">
<?php
$server = "db04.puretec.de";
$db = "db24905524";
$login = "p343302";
$pass = "90f42902";
$dbwww = mysql_connect($server,$login,$pass);
mysql_select_db($db,$dbwww);
$query = "select * from amigaplusnews_content where id = $newsentry limit 1";
$query_result = mysql_query($query,$dbwww);
list($id,$timestamp,$title,$link,$source,$text,$category,$author,$target,$visible) = mysql_fetch_row($query_result);
?>
<p><b><font size="+1">AmigaPlus News Admin</font></b></p>
<p><a href="index.php">zurück</a></p>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#0099FF"><b>News ändern</b></td>
</tr>
<tr>
<td>
<form name="update_news" method="post" action="update_news.php">
<input type="hidden" name="id" value="<?php echo $id ?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="150" valign="top">
<div align="left">Überschrift</div>
</td>
<td>
<input type="text" name="title" size="50" maxlength="200" value="<?php echo $title ?>">
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">
<p>Newstext</p>
<p><font size="-1">Zeilenumbrüche nur machen wenn auch wirklich
ein Absatz erscheinen soll in den News.</font></p>
</div>
</td>
<td>
<textarea name="newstext" cols="70" rows="10" wrap="VIRTUAL"><?php echo $text ?></textarea>
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Link</div>
</td>
<td>
<input type="text" name="link" size="50" maxlength="200" value="<?php echo $link ?>">
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Quelle</div>
</td>
<td>
<input type="text" name="source" size="50" maxlength="100" value="<?php echo $source ?>">
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Autor</div>
</td>
<td>
<select name="author">
<?php
$query = "select * from amigaplusnews_authors order by short_name asc";
$query_result = mysql_query($query,$dbwww);
while($row = mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row["id"] ?>" <?php if($row["id"]==$author) { echo "selected"; } ?>><?php echo $row["short_name"]." - ".$row["full_name"]; ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Kategorie</div>
</td>
<td>
<select name="category">
<?php
$query = "select * from amigaplusnews_categories order by name asc";
$query_result = mysql_query($query,$dbwww);
while($row = mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row["id"] ?>" <?php if($category==$row["id"]) { echo "selected"; } ?>><?php echo $row["name"] ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Zielframe/fenster</div>
</td>
<td>
<input type="text" name="target" value="_blank" maxlength="100" value="<?php echo $target ?>">
</td>
</tr>
</table>
<input type="submit" name="submit" value="speichern">
</form>
</td>
</tr>
</table>
<p> </p>
</body>
</html>